<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Welcome extends CI_Controller {

	/**
	 * Index Page for this controller.
	 *
	 * Maps to the following URL
	 * 		http://example.com/index.php/welcome
	 *	- or -  
	 * 		http://example.com/index.php/welcome/index
	 *	- or -
	 * Since this controller is set as the default controller in 
	 * config/routes.php, it's displayed at http://example.com/
	 *
	 * So any other public methods not prefixed with an underscore will
	 * map to /index.php/welcome/<method_name>
	 * @see http://codeigniter.com/user_guide/general/urls.html
	 */
	public function index()
	{
		$this->load->database();
		$sql0 = "INSERT INTO `user` (pusername, ppassword, pusertype) VALUES ('Haozi', '123456', '1')";
		$sql = "SELECT * FROM user limit 0,10";
// 		for ($i = 0; $i < 14000; $i++) {
// 			$query = $this->db->query($sql0);
// 		}
		$query = $this->db->query($sql);
		foreach ($query->result() as $row)
		{
			echo "ID:".$row->pid.'<br />';
			echo "name:".$row->pusername.'<br />';
			echo "password:".$row->ppassword.'<br />';
			echo "usertype:".$row->pusertype.'<br />';
			echo '<hr />';
		}
		//$this->load->view('welcome_message');
	}
}

/* End of file welcome.php */
/* Location: ./application/controllers/welcome.php */